Split Function
Creates a one-dimensional array from the String passed.
Syntax
result = Split( source, [delimiter] )
Parameters | ||
source |
Source string to be parsed into an array. |
|
delimiter (Optional) |
Optional field delimiter used to parse Source into array elements. If delimiter is omitted, then a space is used as the delimiter. |
Notes
Use the Split function to create a new String array from a list of elements (or fields) that are separated by a delimiter. If the optional parameter, delimiter, is not passed, a single space is assumed as the delimiter. If the delimiter is an empty string, the source string is split into characters.
Examples
The first example specifies the comma delimiter and the second example uses the default delimiter. They place each field into an array element, producing a three-element array. The last example parses the string into individual characters.
anArray=Split ("Adam,Aardvark,Accountant",",")
anArray=Split("Adam Aardvark Accountant")
anArray=Split("Adam","")
//First two using the alternate syntax:
Dim s as String
s="Adam,Aardvark,Accountant"
anArray=s.Split (",") //produces 3-element array
anArray=s.Split("")//produces array of individual characters
See Also
String data type; Dim statement; Array, Join, NthField, Ubound functions; Append, IndexOf, Insert, Pop, Redim, Remove, Shuffle, Sort, Sortwith methods; ParamArray keyword.